Home page
Release Information
Reality on the Web
MultiValue Compatibility
Documentation Overview
Installation Guides
User's Reference
English Reference
Proc Reference
DataBasic Reference
About this Section
Contents
References
Abbreviations and Conventions

Introduction to DataBasic
DataBasic Elements
Program Elements
Multi-statement Line
Line Continuation
Identifiers
Reserved Words
Statement Labels
Comments
Blank Spaces and Lines
Program Storage
Naming a Program

Subroutines
Internal Subroutine
External Subroutine

Including Common Code
Defining Code to be Automatically Included
Order of Included Code

Literals, Symbols and Variables
Numeric Literals
String Literals
Symbols
Variables

Assignments
Arithmetic Expressions
Precedence
Parentheses
Strings in Arithmetic Expressions
Examples

String Expressions and Concatenation
Substring Expression
Concatenation
Examples

Substring Extraction
Substring Assignment
Relational Expressions
Relational Operators
Arithmetic Relations
String Relations
Pattern Matching

Logical Expressions
Assignment Operators
Using the THEN/ELSE and ON ERROR Clauses
Syntax of THEN/ELSE
Syntax of ON ERROR Clause
Statements using THEN/ELSE
Statements using ON ERROR
Examples

Format Strings
Syntax
Operation
Examples of Format Strings

Conversions
Output Conversions
Input Conversions
Date Output Conversions
External to Internal Date Conversion
Mask Character Conversions
User Exit Conversions
TCL Commands that Modify Conversions

Execution and Item Locks
Execution Locks
Item Locks
TCL Commands Related to Locks

Introducing Arrays
Dimensioned Array
Dynamic Array
Further Information

Dimensioned Arrays
Syntax
Dimensioning an Array
Accessing Array Elements
Using MATWRITE{U} and MATREAD{U}
Writing a Matrix to Disk

Dynamic Arrays
Syntax
Element Delimiters
Data Extraction and Replacement
Data Insertion and Deletion
Dynamic Array Examples
Program Examples
Data Extraction Examples
Data Replacement Examples
Rules for Dynamic Array References

Dynamic Arrays vs. Dimensioned Arrays
Dynamic Arrays
Dimensioned Arrays
Rules of Usage

Using Indexes

Statements and Intrinsic Functions
Statements and Functions by Category
$CHAIN Statement
$OPTIONS Statement
@ Function
A
ABORT Statement
ABS Function
ACCEPT Statement
ACCESS Function
ALPHA Function
ASCII Function
ASSIGN Statement

B
BCC Function
BITCHANGE Function
BITCHECK Function
BITLOAD Function
BITRESET Function
BITSET Function
BREAK Statement

C
CALL Statement
CASE Statement
CHAIN Statement
CHANGE Function
CHAR Function
CHECKSUM Function
CLEAR Statement
CLEARDATA Statement
CLEARFILE Statement
CLEARSELECT Statement
CLOSE Statement
CLOSESEQ Statement
COLLECTDATA Statement
COL1/COL2 Functions
COMMON Statement
COMPARE Function
CONNECT Statement
CONVERT Function
CONVERT Statement
COS Function
COUNT Function
CRC Function
CRT Statement

D
DATA Statement
DATE Function
DCOUNT Function
DEBUG Statement
DECRYPT Function
DEL Statement
DELETE Function
DELETE Statement
DELETELIST Statement
DELETESEQ Statement
DIMENSION Statement
DISCONNECT Statement
DOWNCASE Function
DQUOTE Function
DTX Function

E
EBCDIC Function
ECHO Statement
ENCRYPT Function
END Statement
ENTER Statement
EQUATE Statement
EXP Function
EXTRACT Function

F
FIELD Function
FIND Statement
FINDSTR Statement
FLUSH Statement
FMT Function
FOLD Function
FOOTING Statement
FOR Statement

G
GETLIST Statement
GETMSG Function
GOSUB Statement
GOTO Statement
GROUP Function
GROUPSTORE Statement

H
HEADING Statement

I
ICONV Function
IF Statement
IN Statement
INCLUDE Statement
INDEX Function
INPUT Statement
INPUT CTRL Statement
INPUT@ Statement
INPUTCLEAR Statement
INPUTERROR Statement
INPUTNULL Statement
INPUTTRAP Statement
INS Statement
INSERT Function
INT Function

L
LEN Function
LET Statement
LN Function
LOCATE Statement
LOCK Statement
LOOP Statement
LOWER Function

M
MAT Statement
MATBUILD Statement
MATPARSE Statement
MATREAD Statement
MATREADU Statement
MATWRITE Statement
MATWRITEU Statement
MAXIMUM Function
MINIMUM Function
MOD Function

N
NEXT Statement
NOT Function
NULL Statement
NUM Function

O
OCONV Function
ON GOSUB Statement
ON GOTO Statement
OPEN Statement
OPENSEQ Statement

P
PAGE Statement
PAUSE Statement
PERFORM Statement
POSITION Statement
PRECISION Statement
PRINT Statement
PRINTER Statement
PRINTERR Statement
PROCREAD Statement
PROCWRITE Statement
PROGRAM Statement
PROMPT Statement
PTR Function
PWR Function

R
RAISE Function
READ Statement
READBLK Statement
READLIST Statement
READNEXT Statement
READPREV Statement
READSEQ Statement
READT Statement
READU Statement
READV Statement
READVU Statement
RECEIVE Statement
RECORDLOCKED Function
RECWAIT Statement
RELEASE Statement
REM Function
REM Statement
REMOVE Statement
REPEAT Statement
REPLACE Function
RETURN Statement
REWIND Statement
RND Function
ROUND Function
RQM Statement
RTNDATA Statement

S
SEEK Statement
SELECT, SELECTE Statements
SELECTINFO Function
SEND Statement
SENTENCE Function
SEQ Function
SIN Function
SLEEP Statement
SORT Function
SOUNDEX Function
SPACE Function
SPOOLER Function
SQRT Function
SQUOTE Function
STOP Statement
STR Function
SUBROUTINE Statement
SUM Function
SUMMATION Function
SYSTEM Function
SYSTEM Statement

T
TAN Function
TIME Function
TIMEDATE Function
TRANSABORT Statement
TRANSEND Statement
TRANSQUERY Function
TRANSTART Statement
TRIM/TRIMB/TRIMF Functions
TRUNC Function

U
UNASSIGNED Function
UNLOCK Statement
UNTIL Statement
UPCASE Function

V
VARTYPE Function
VARVAL Function
VARVALSET Statement
VARVALTYPE Function

W
WAKE Statement
WEOF Statement
WEOFSEQ Statement
WHILE Statement
WRITE Statement
WRITEBLK Statement
WRITELIST Statement
WRITESEQ Statement
WRITET Statement
WRITEU Statement
WRITEV Statement
WRITEVU Statement

X
XTD Function

Related TCL Commands
BASIC
BLIST
BREF
BVERIFY
CATALOG
CLEAR-BASIC-LOCKS
DB
DEBUG
DECAT
DELETE-CATALOG, DECATALOG
ECOPY
END
LOAD-BNF
PRINT-CATALOG
RUN

Programming in DataBasic
Programming Hints
Using System Delimiters
Cursor Positioning
Opening Files
Repeating Operations
Unknown Number of Values
Modifying a Program

Running a DataBasic Program in a Proc
Interprocess Communication
Sequential File Access
Embedded Basic Subroutines
How to Write an Embedded Basic Subroutine
Embedded Basic Examples
Debugging Embedded Basic Subroutines
How to Associate a Trigger with a File
Triggers Dos and Don’ts

Efficiency Guidelines
Internal Storage
Numeric Operations
Dynamic Arrays
File Open and Close
File Input and Output
Locking
PERFORM
Efficient Use of Subroutines
Miscellaneous
Using the DataBasic Profiler

Programming Examples
INV-INQ Program Example
Area Program Example
Profits Program Example
Program Example Using Transaction Boundaries
Program Examples using Interprocess Communication
ORDER Client/Server
FPUT Client/FGET Server
PERFORM Client/Server
TCP Client/Server
TCP Ping
TCP Email

DataBasic Development Program Example
DataBasic Real-time Run Program Example

The Debugger
Overview
Entering the Debugger
Nested Programs

Variables
Symbol Table
Enabling and Disabling the Debugger

Summary of Debugger Commands
$
/
?
@
A
B
D
DE{BUG}
E
END
G
K
L
LD
LP
M
N
OFF
P
PC
S
T
U
V
W
WF
WS
X
Z

Terminal Types
User Exit Conversions
File I/O and IPC Error Codes
File I/O Error Codes
IPC Error Codes

Printer Independent Functions
Introduction to Printer Independence
Printer Independent Functions
Function Classes

Using Alternative Compilers
Overview
Procedure
Using the BASIC Command with the C option
Previous Releases

TCP Parameters
Port Numbers
Options

Redefining User Exits
MultiValue Compatibility
Features that Depend on the Compatibility Mode
Reality Features with Additional Functionality
Additional Features
DataBasic Elements
Statement Labels
Predefined Symbols
Substring Extraction
Pattern Matching
Strings as Logical Expressions
Format Strings
Item Locks
User Exits

Statements and Intrinsic Functions
$OPTIONS Statement
@ Function
ASSIGNED Function
CLEARINPUT Statement
CREATE Statement
DCOUNT Function
DELETESEQ Statement
EQUATE Statement
EXECUTE Statement
FIELD Function
FORMLIST Statement
GROUP Function
IN and INPUT Statements
LOCATE Statement
MATPARSE Statement
MOD Function
ON GOSUB and ON GOTO Statements
OPENSEQ Statement
READLIST Statement
READNEXT Statement
READPREV Statement
REMOVE Statement
SELECT Statement
STATUS Function
SUM Function
SWAP Function
SYSTEM Function

Editor Reference
Screen Editor Reference
Resilience
SQL for Reality
UNIX-Connect
External Interfaces
Other Documents